Skip to main content

What’s New

Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
NodeJS Deprecation
AWS has announced that it is deprecating NodeJS 12, 14, and 16. To avoid any issues as a result of this deprecation, upgrade your instances of the Qrvey platform as described in this announcement.
Learn More
Version: 8.5

General Chart Settings

This section is available for all chart types, however the options in it vary among chart types. All available options, regardless of the applicable chart type, have been listed in alphabetical order and briefly described in this article. Options that are specific to some charts are discussed in more detail in the individual chart type articles and a link is provided where applicable.

Aggregated Formulas​

This feature allows you to create a new column of data using a formula that is based on the aggregated columns in a table chart and is explained in more detail in the Table Charts article.

  • Default: –
  • Applies to: Grouped Tables

Allow Pagination​

This checkbox is only available for ungrouped Table charts and works in conjunction with the Max Rows value. If it is unchecked (default), the table appears without pagination and displays a maximum of rows as selected in the Max Rows control (500 by default), in one long table. If selected, the table will break into smaller pages, each containing 30 rows by default. In this case, the Max Rows control is replaced with Records Per Page control, which determines the number of records displayed per page of the table. In this mode, you can page through all of the data in the dataset.

  • Default: Off
  • Applies to: Ungrouped Tables

Display Averages​

This checkbox is available for Min/Max charts and plots the average point for each data point if it is checked.

  • Default: Off
  • Applies to: Min/Max charts

Fixed Scale​

This checkbox is only available for Dial and Bullet gauges and allows you to determine the lower and upper limits of the chart.

  • Default: Off
  • Applies to: Dial Gauge, Bullet Gauge

Freeze First Column​

This checkbox is only available for Expandable Table charts and it keeps the first column in place if the table is scrolled horizontally. It is checked by default.

  • Default: On
  • Applies to: Expandable Tables

Labels​

Labels checkbox controls showing or hiding labels for Rows and Columns in Crosstab Charts. When the Labels checkbox is marked, an Edit option is automatically added in the three-dot button of the label box. The additional option of Sorting also appears, in the form of another checkbox. Turning on that option adds sorting icons inside the label boxes.

general

  • Default: Off
  • Applies to: Crosstab

Legends​

This setting is available for charts that support legends, like all multi-series charts, the Combo and Pie charts, as well as most metric and map charts. When on, legends are displayed as colored boxes above the chart, showing the category that is represented by the color. Thresholds have to be defined for metric charts before legends are displayed. Legends can be turned off or on from the icons shown in the following image. By default, legends are turned on.

general

general

  • Default: On
  • Applies to: Multi-Series Bar, Multi-Series Line, Multi-Series Symbol, Combo, Pie, Dial, Bullet, Heatmap, Bubble Map, Choropleth Map

Max Data Points / Max Slices​

Here you can set the maximum number of data points you’d like to display in your chart. By default, the Max Data Points limit is set to 50 for performance reasons, but it can be set to a lower or higher number. To define the max number of data points in your chart, set the desired number in the box which will immediately be reflected in the chart preview. Keep in mind that selecting a large number of data points may cause the charts to have longer loading times.

general

Note: If it appears that your chart is missing data, check the Max Data Points section and increase the limit to show more data on your chart.

Note 2: The same setting changes name to Max Slices for pie charts.

  • Default: 50
  • Applies to: Bar, Line, Symbol, Multi-Series Bar, Multi-Series Line, Multi-Series Symbol, Dot Map, Bubble Map, Choropleth Map, Pie, Heatmap, Box & Whisker, Word Cloud

Overriding the Max Data Points Setting​

When exporting charts, you can configure the Qrvey platform to override the value set in the Max Data Points field and always export all data. This override is configured using the Backend API. It affects the CSV, CSV Summary, Excel, and PDF export features. For more information, see Exporting Data.

Max Groups​

This control applies to grouped tables (default 50) and expandable tables (default 10) and determines the maximum number of groups. The setting is there for performance reasons and to prevent accidental grouping of data fields with too many unique values that may result in an excessive number of groups.

Max Rows / Max Columns​

These are fields in Crosstab Charts where you can set a maximum limit on the number of rows or columns you want to show. The maximum number of data points is 10,000 in total - this includes both rows and columns, combined.

  • Default: 500 (Rows), 50 (Columns)
  • Applies to: Crosstab

Max Series​

This field lets you increase or decrease a limit on the series you want to show in a single category in a multi-series chart, which is by default set to 50.

  • Default: 50
  • Applies to: Multi-Series Bar, Multi-Series Line, Multi-Series Symbol

Table Charts offer some options in interaction mode (when the chart is saved and placed on the dashboard). The Edit and Multi-column Sort options are always available from the three-dot menu in the header of each column. The availability of the two other options, Sorting and Visualization, can be controlled from this section. When Sorting is checked, it adds the sorting button (add) to the column header for all columns. When Visualization is checked, the command is added in the three-dot menu of numeric columns and allows users to decide whether they want values to be displayed as numeric or as bars.

general

Records per Group​

This value controls the maximum number of rows that are retrieved for each group in expandable tables and defaults to 10.

Sort by​

All charts offer sorting capability on their various data columns, however the access point to the sorting options may vary. The Sort by option in the General configuration is available for a handful of charts - like the pie chart - that have a simple sorting use case by either the selected category or values column. Default sorting depends on the selected chart and the data types of the selected columns. However, you can switch between sorting by the category column and value column by clicking on the ABC and 123 icons, respectively. You can also change the direction of sorting from ascending to descending and back, by clicking on the sort direction icons on the right.

general

For more information, see Sorting.

  • Default: Values column descending (Pie), Category column ascending (Heatmap)
  • Applies to: Pie , Heatmap

Subtotals​

This option only applies to Crosstab charts and adds subtotals for each column, when more than one category has been added to Columns.

Table Calculations​

Various standard functions can be used to calculate values based on data within the chart. Each table calculation function results in a new column of data that can be plotted in the chart. An example of such a table calculation function is the “running total” of a value within any given group. Read more about configuring Table Calculations here.

Tooltips​

This section enables you to add Tooltips based on any column to most chart types.

  • Default: On
  • Applies to: All charts other than Table, Crosstab, Expanded Table

Totals​

Totals is an option for all table chart types and is described in detail in those articles. The option allows for aggregations to be added to rows and columns in Crosstab charts and aggregations for columns in the other types of Table charts.